Previous Topic

Next Topic

To change the sort fields

The field format for entering data is Table.FIELD. The table name appears first in title case, followed by a period separator and the field name in all caps, for example, Name.FULL_NAME. The Alternate Sort Fields window allows you to enter the Table.FIELD name for a maximum of four sort fields. To specify a multiple-field sort, enter the first-order sort field in the first text box, working down to the lowest-level sort field in the fourth text box. The sort fields you enter must be selected from the tables used for the report.

Note: For some report types, the Sort option is grayed out (unavailable) on the Options list.

  1. From the module you are working in, select Generate reports to display the Generate reports window.
  2. Select a report type from the Report Types list.
  3. Select a report from the Available Reports list.
  4. Click Options and select Sort Fields. The areas you can change appear bolded. For example, using the data in the following window, your report sorts in the following order: last name, ID, and product code.
  5. Change the alternate sort fields to new sort fields selected from the tables to be included in the report.
  6. Click OK to change the sort order.

Example of an Alternate Sort Fields window.

See Also

Modifying a Standard Report

To view report options

To adjust margins


ASI logo 10.6 Production Release. Updated 2/21/2006 11:44:33 AM
© 2009 by Advanced Solutions International, Inc. All rights reserved.